package com.byhealth.spus.dao;

import java.util.List;

import org.springframework.jdbc.core.simple.ParameterizedBeanPropertyRowMapper;
import org.springframework.stereotype.Repository;

import com.byhealth.act.base.dao.AbstractBaseDao;
import com.byhealth.spus.entity.SpusData;

@Repository("healthyServiceSpusData")
public class HealthyServiceSpusData extends AbstractBaseDao{
	

	private static final String TABLE_NAME = "healthy_service_spus_data";
	
	private static final String ID = "spus_id";
	
	private static final String ID_PROPERTY = "spusId";
	
	public SpusData test(){
		String sql = "select * from healthy_service_spus_data ";
		List<SpusData> list = jdbcTemplate.query(sql, 
				new ParameterizedBeanPropertyRowMapper().newInstance(SpusData.class));
		return list.get(0);
	}
}
